Skip to main content

What’s New

Qrvey 8.5
Version 8.5 (LTS) of the Qrvey platform is now available to customers. This version includes several new features and performance improvements.
Learn More
End-of-life Schedule
We've added a new article that lists the features and endpoints that have been scheduled for deprecation. All features and endpoints will be supported for (1) year after the release date of the LTS version that contains the alternative.
Learn More
NodeJS Deprecation
AWS has announced that it is deprecating NodeJS 12, 14, and 16. To avoid any issues as a result of this deprecation, upgrade your instances of the Qrvey platform as described in this announcement.
Learn More
Version: 8.5

Data Joins

The Join Data feature enables you to create a new dataset by joining multiple data sources from multiple connection types. The existing datasets must have at least one column in common in order to be joined.

Join Types​

The following join types are supported:

  • Left Join - Uses rows of data from the left table and the matching rows from the right table.
  • Full Join - Uses all records in all joined tables.
  • Inner Join - Uses only the rows of data that are common in the joined data. Rows that have no commonality between datasets are excluded.
  • Right Join - Same as the left join, it uses rows of data from the right table and the matching rows from the left table.

To Create a Joined Dataset​

  1. On the Design page, click the three-dot menu on the data source pill, and select Join to Another Data Source. For more information on using the Design page, see Overview of the Design Page.

data-joins

  1. On the Select the Data Source dialog, select the data source that you wish to join. Click the Connection, My Data, or Shared Data tabs to display existing data sources.

  2. Click Next. The Join Data dialog displays.

joins

  1. Under Join Type, select the join type that you would like to use.

  2. Click the dropdown box for each dataset and select the common columns. You can select more than one column for each link.

  3. Click Save. The Join Output pill displays on the Design page.

3_joins

  1. Click Join Output to display all the combined columns from the joined datasets. This is the view of the output columns that will be loaded to the dataset. Click on any data source pill to filter the view to show only columns from the selected data source.

  2. Repeat the join process as needed to achieve the desired structure for your dataset.

  3. Click Apply Changes to make the joined datasets available to create charts, pages, and reports.

To Filter the List of Columns​

A joined dataset may include a large number of columns that can be difficult to navigate. To filter the list of columns, click a data source pill. The list updates to display only the columns in that data source.

To Delete a Joined Dataset​

To delete a joined dataset, click its three-dot menu and select Delete.